package com.autcar.training.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.HashMap;
import java.util.Map;

/**
 * @ProjectName: training
 * @Package: com.autcar.training.dao
 * @ClassName: CountMapper
 * @Author: YHHHH
 * @Description: 报表统计接口
 * @Date: 2020/9/2 17:37
 * @Version: 1.0
 */
@Mapper
public interface CountMapper  {
    //客户统计
    @Select("select count(1) from customer")
    Integer customerCount();

    //订单统计
    @Select("select count(1) from g_order")
    Integer orderCount();

    //商品统计
    @Select("select count(1) from goods")
    Integer goodsCount();

    //工作人员统计
    @Select("select count(1) from worker")
    Integer workerCount();

}
